/*
 * version date author 
 * ────────────────────────────────── 
 * 1.0  Nov 28, 2012 Neal Miao 
 * 
 * Copyright(c) 2012, by HTWater. All Rights Reserved.
 */
package cn.miao.demo.service.impl;

import java.util.List;
import java.util.Map;

import cn.miao.demo.service.TestService;
import cn.miao.framework.dao.BaseDao;
import cn.miao.framework.factory.DaoFactory;

/**
 * 
 * 
 * @author Neal Miao
 * @version
 * @since v 1.0
 * @Date Nov 28, 2012 3:16:42 PM
 * 
 * @see
 */
public class TestServiceImpl implements TestService {

	/* (non-Javadoc)
	 * @see cn.miao.demo.service.TestService#getSomething()
	 */
	public List<Map<String, Object>> getSomething() {
		BaseDao dao = DaoFactory.getDao(SQLSERVER1);
		String sql = "SELECT rtrim(RB.STCD) as STCD,SB.STNM,RB.VALLEY,RB.RSNM " +
				"FROM HT_RAIN_B AS RB LEFT JOIN HT_STBPRP_B AS SB ON RB.ST_ID=SB.ID " +
				"WHERE ISRSVR=1 AND ENABLED=1 ORDER BY RB.ORDNO desc";
		return dao.executeQuery(sql);
	}

}
